﻿CREATE TABLE [Global].[Constant]
(
	[ConstantID] BIGINT IDENTITY(1,1) NOT NULL CONSTRAINT [GLOBAL_Constant_ConstantID] PRIMARY KEY, 	
	[ConstantName] NVARCHAR(250) NOT NULL CONSTRAINT [GLOBAL_Constant_ConstantName] UNIQUE,
	[ConstantType] NVARCHAR(100) NOT NULL CONSTRAINT [GLOBAL_Constraint_ConstantType] DEFAULT ('UNKNOWN'),
	[ConstantValue] NVARCHAR(500) NOT NULL CONSTRAINT [GLOBAL_Constant_ConstantValue] DEFAULT ('NONE'),
	[ConstantDesc] NVARCHAR(500) NOT NULL CONSTRAINT [GLOBAL_Constant_ConstantDesc] DEFAULT ('NONE'),
	[CreatedBy] NVARCHAR(250) NOT NULL CONSTRAINT [GLOBAL_Constant_CreatedBy] DEFAULT SYSTEM_USER,	
	[DateCreated] DATETIME NOT NULL CONSTRAINT [GLOBAL_Constant_DateCreated] DEFAULT GETDATE(), 
	[DateDeleted] DATETIME NULL,
	[VersionUser] NVARCHAR(250) NOT NULL CONSTRAINT [GLOBAL_Constant_VersionUser] DEFAULT SYSTEM_USER,
	[VersionDate] DATETIME NOT NULL CONSTRAINT [GLOBAL_Constant_VersionDate] DEFAULT GETDATE()
)
